<%-- 
    Document   : regsuccess.jsp
    Created on : Oct 9, 2009, 6:22:16 PM
    Author     : Bharath
--%>

<%@page contentType="text/html" pageEncoding="UTF-8" import="Registration.*, Login.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<%@ page import="java.io.* ,java.util.*, java.sql.*, Login.* "%>
<link href="style.css" rel="stylesheet" type="text/css">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Registration</title>
        
    </head>
    <%
       
                
        MySqlConnector ms = new MySqlConnector();
        //RegistrationBean rb = new RegistrationBean();
        Connection con = ms.Connect();
        HttpSession hs = request.getSession(true);
        String memid = (String) hs.getAttribute("regmemid");
        String password = (String) hs.getAttribute("regpassword");
        System.out.print(" ---------  member id in success jsp is : "+memid);
        System.out.print(" ---------  password ...........is  : "+password);
        // String memid  = rb.getMemberid();
       // String pass  = rb.getPassword();
       // System.out.print("Member id............ is  : "+memid);
       // System.out.print("password ...........is  : "+pass);

        String q = "select * from registration where memberid = '"+memid+"' and status = '0' ;";
        PreparedStatement ps = con.prepareStatement(q);
        System.out.print("Query is   : "+q);
        ResultSet rs = ps.executeQuery();
        System.out.print("result set is  : "+rs);
    %>
    <body bgcolor="#FDFEE9">
      
        <p>&nbsp;</p>
        <table width="492" height="180" border="0" align="center" bordercolor="#0000FF" class="greenlink_no_left_padding">
            <tr>
              <td colspan="2" bgcolor="#D8F2C9"> <div align="center" class="redtext">RESGISTRATION DETAILS</div></td>
            </tr>
            <tr>
               <% if (rs.next() == true) 
                {
                System.out.print(" ---------in if field jsp  ---------");
                String mid= rs.getString(1);
                System.out.print(" id of the member"+mid);
                %>
			    <td width="142" class="style1">Member Id </td>
				
                <td width="340" class="style2"><%=mid%></td>
            </tr>
            <tr>
                <% String mname = rs.getString(3);
                System.out.print("name of the member is "+mname);

                        %>
                <td class="style1">Member Name </td>
                <td class="style2"><%=mname%></td>
            </tr>
            <tr>
                <td class="style1">Mobile Number </td>
                <td> <span class="style2"><%=rs.getString(19)%> </span></td>
            </tr>
            <tr>
                <td class="style1">Email </td>
                <td> <span class="style2"><%=rs.getString(20)%> </span></td>
            </tr>
            <tr>
                <td class="style1">State </td>
                <td> <span class="style2"><%=rs.getString(14)%> </span></td>
            </tr>
            <tr>
                <td class="style1">District</td>
                <td> <span class="style2"><%=rs.getString(15)%> </span></td>
            </tr>
            <tr>
                <td class="style1">Mandal</td>
                <td> <span class="style2"><%=rs.getString(16)%> </span></td>
            </tr>
    </table>
   
     
	    <p>&nbsp;</p>
	    <p>&nbsp;</p>
	    <p>&nbsp;</p>
	    <p>&nbsp;</p>
	    <p><span class="dash-link">Your Password is </span><span class="banner380">:<%=password%></span><span class="dash-link">
          <strong>This is a auto generated password, you can change when ever you what to !</strong>! <a href="whos.jsp"><strong>LOGIN</strong> </a> </span>
          <%}%>
                    </p>
    </body>
</html>
